You are here: Tools > Mapper > Mapper I > Using Mapper I

Using Mapper I

When files are to be updated, they must be created in comma separated variable .csv format in the correct layout for the data to be uploaded and placed where they are accessible .

  1. Mapper is accessed by selecting the Mapper icon on the Toolbar.
  2. By selecting File thenOpenfrom the Mapper toolbar, a list of files are displayed.
  3. Select the Import file name, followed by OK.
  4. Use the Browse button to select the corresponding .csv file.
  5. By default, Perform Update will be selected.
  6. Clear file before importing, this field becomes available for selected files.
    • If selected, the file into which the data is being uploaded will be cleared before the import is performed.
    • If not selected, the data being produced will be appended to the existing file.
  7. Select Run to begin the selection process.
    • The Mapper update process produces a report which details the number of records which have been inserted into the system and any errors found.

 

ClosedUploading Type B - Batch Maintenance files

This type of upload is used for the series of PAY02T files which are designed specifically to load new employees into database and amending records.

The files which may be uploaded by this process are marked in the list of files available with 'B' in the "Upload Type" field.

  1. Prepare the .csv files to be uploaded. Data is extracted from an Excel spreadsheet PAY02T, and will contain multiple worksheets. A Mapper script will need to be run to separate each worksheet into single files and saved into .csv files.
  2. The Mapper script can be found on the Neller Intranet > Neller Home > Professional Services > Imp. Documents > Mapper & PAY02T Template.
  3. After the Mapper script has been run, each worksheet is saved into separate files with their corresponding worksheet names. e.g. PAY02T50 Emp Name & Address is saved as 'PAY02T50.csv'.
  4. A Change Reason code of 'UPLOAD' can be added for all new employees, by using the 'Edit', 'Replace' option in Notepad.
    Open files PAY0250 to PAY0254 and replace the date at the end of each line with the date and the reason code of 'UPLOAD'.
  5. Save the file in .csv format and the Save as Type is 'All Files'.
  6. Follow the Mapper process described above to select and upload the files. All the files which are processed by this upload method may be uploaded before proceeding to the next stage.
  7. Run the Personnel > Bulk Maintenance > Batch Processing > Edit Batch Maintenance process to validate the files.
  8. Correct any errors which may be shown in the Edit reports, this may involve adding records to reference tables or amending the data that has been loaded and re-imported.
  9. When all is correct, run the Update Batch Maintenance process to update the file with the new information.
  10. Run the Bulk Position Allocation for first time, new employees (50-54), and only if a position has not been setup. The default position code of '9999' can be used.